<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<sql:setDataSource dataSource="jdbc/ag7_test" />

<%
	if((String)session.getAttribute("openid")==null) { 
		String message = "you are not logged in. please log in first.";
		session.setAttribute("message", message);
		response.sendRedirect("login.jsp"); return; 
	}
%>

<jsp:include page="header.jsp"/>
 
<FORM METHOD="POST" ACTION="writebackHandleCoordinates">
<br/>

<div id="table">
<table>
<%--table BORDER="0" CELLSPACING="0" CELLPADDING="0" WIDTH="650" bgcolor="#FFFFCC">--%>

<tr id="row1">
  <td  colspan="3"><H2>Please choose :</H2></td>
</tr>

<!--  http://www.ensembl.org/img/nav-bg.gif-->

<%-- <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="3" WIDTH="650" bgcolor="#FFFFCC">--%>

<tr id="row0">
<TD ALIGN=CENTER><input type="radio" name="group1" value="1" CHECKED><B> ADD NEW FEATURE</B><br><br></TD>
<TD ALIGN=CENTER><input type="radio" name="group1" value="2"><B> MODIFY FEATURE</B><br><br></TD>
<TD ALIGN=CENTER><input type="radio" name="group1" value="3"><B> DELETE FEATURE </B><br><br></TD>
<sql:query var="qryPosts" >
   select id,name,uri from coordinate_system order by name;
</sql:query>

<TR id="row1">
    <td colspan="3" scope="colgroup">COORDINATE SYSTEM :  
    <select name="system" style="width:310px;" >
<c:forEach var="row" items="${qryPosts.rows}">     
   <OPTION value="<c:out value="${row.id}"/>;<c:out value="${row.name}"/>;<c:out value="${row.uri};"/>"> <c:out value="${row.name}" />     
</c:forEach>         
</select>
</td>
</TR>

<TR id="row2">
<TD colspan="2"></TD> 
<TD ALIGN=center><P>
<INPUT TYPE="submit" class="red-button" VALUE="Submit" ></P></TD>
</TR>

</TABLE>
</div> <%-- closes the table div --%>


</FORM>
<%-- <script language="JavaScript" src="/js/omi/jsc/s_code_remote.js"></script>--%>

<jsp:include page="footer.jsp"/>

